"""Build .docx from paper.md + all output tables."""

import re
from pathlib import Path
from docx import Document
from docx.shared import Inches, Pt, Cm, RGBColor
from docx.enum.text import WD_ALIGN_PARAGRAPH
from docx.enum.table import WD_TABLE_ALIGNMENT

PROJECT = Path("/mnt/c/demographics_capital_flows/net_gross")
TABLES_DIR = PROJECT / "output" / "tables"
FIGURES_DIR = PROJECT / "output" / "figures"
PAPER_MD = PROJECT / "paper" / "paper.md"
OUTPUT = PROJECT / "paper" / "net_gross_paper.docx"


def set_cell_text(cell, text, bold=False, size=Pt(9), font_name='Times New Roman'):
    cell.text = ""
    p = cell.paragraphs[0]
    p.alignment = WD_ALIGN_PARAGRAPH.CENTER
    run = p.add_run(text)
    run.font.size = size
    run.font.name = font_name
    run.bold = bold


def add_md_table(doc, md_text, title=None):
    lines = [l.strip() for l in md_text.strip().split('\n') if l.strip()]
    table_lines = [l for l in lines if '|' in l and not l.startswith('#')]
    if not table_lines:
        return

    rows = []
    for line in table_lines:
        cells = [c.strip() for c in line.split('|')]
        cells = [c for c in cells if c != '']
        if all(set(c) <= set('-: ') for c in cells):
            continue
        rows.append(cells)

    if len(rows) < 2:
        return

    if title:
        p = doc.add_paragraph()
        run = p.add_run(title)
        run.bold = True
        run.font.size = Pt(11)
        run.font.name = 'Times New Roman'

    n_cols = max(len(r) for r in rows)
    table = doc.add_table(rows=len(rows), cols=n_cols)
    table.style = 'Light Shading'
    table.alignment = WD_TABLE_ALIGNMENT.CENTER

    for i, row_data in enumerate(rows):
        for j, cell_text in enumerate(row_data):
            if j < n_cols:
                set_cell_text(table.cell(i, j), cell_text, bold=(i == 0))

    doc.add_paragraph()


def parse_md_file(filepath):
    text = filepath.read_text()
    sections = []
    lines = text.split('\n')
    current_title = None
    table_buf = []

    for line in lines:
        if line.startswith('#'):
            if table_buf:
                sections.append(('table', current_title, '\n'.join(table_buf)))
                table_buf = []
            current_title = re.sub(r'^#+\s*', '', line).strip()
        elif '|' in line:
            table_buf.append(line)
        elif line.strip().startswith('*') and not table_buf:
            sections.append(('note', line.strip()))

    if table_buf:
        sections.append(('table', current_title, '\n'.join(table_buf)))

    return sections


def sanitize_math(math_text):
    for old, new in [('\\text{', ''), ('}', ''), ('\\log', 'log'),
                     ('\\cdot', '\u00b7'), ('\\cdots', '...'),
                     ('\\varepsilon', '\u03b5'), ('\\alpha', '\u03b1'),
                     ('\\beta', '\u03b2'), ('\\gamma', '\u03b3'),
                     ('\\delta', '\u03b4'), ('\\Delta', '\u0394'),
                     ('\\hat', ''), ('\\widehat', ''),
                     ('\\sum', '\u03a3'), ('\\exp', 'exp'),
                     ('\\times', '\u00d7')]:
        math_text = math_text.replace(old, new)
    math_text = re.sub(r'\\[a-zA-Z]+', '', math_text)
    math_text = re.sub(r'_\{([^}]+)\}', r'_\1', math_text)
    math_text = re.sub(r'\^\{([^}]+)\}', r'^\1', math_text)
    math_text = ''.join(c for c in math_text if ord(c) >= 32 or c in '\n\t')
    return math_text


def build_docx():
    doc = Document()

    for section in doc.sections:
        section.top_margin = Cm(2.54)
        section.bottom_margin = Cm(2.54)
        section.left_margin = Cm(2.54)
        section.right_margin = Cm(2.54)

    style = doc.styles['Normal']
    style.font.name = 'Times New Roman'
    style.font.size = Pt(12)
    style.paragraph_format.space_after = Pt(6)
    style.paragraph_format.line_spacing = 1.15

    paper_text = PAPER_MD.read_text()
    lines = paper_text.split('\n')

    i = 0
    while i < len(lines):
        line = lines[i]

        if line.startswith('# ') and not line.startswith('## '):
            title = line[2:].strip()
            p = doc.add_heading(title, level=0)
            p.alignment = WD_ALIGN_PARAGRAPH.CENTER
            for run in p.runs:
                run.font.size = Pt(16)
                run.font.name = 'Times New Roman'
                run.font.color.rgb = RGBColor(0, 0, 0)
            i += 1
            continue

        if line.startswith('## '):
            heading = line[3:].strip()
            p = doc.add_heading(heading, level=1)
            for run in p.runs:
                run.font.size = Pt(14)
                run.font.name = 'Times New Roman'
                run.font.color.rgb = RGBColor(0, 0, 0)
            i += 1
            continue

        if line.startswith('### '):
            heading = line[4:].strip()
            p = doc.add_heading(heading, level=2)
            for run in p.runs:
                run.font.size = Pt(12)
                run.font.name = 'Times New Roman'
                run.font.color.rgb = RGBColor(0, 0, 0)
            i += 1
            continue

        if line.strip().startswith('$$'):
            math_lines = [line.strip().replace('$$', '')]
            i += 1
            while i < len(lines) and '$$' not in lines[i]:
                math_lines.append(lines[i].strip())
                i += 1
            if i < len(lines):
                math_lines.append(lines[i].strip().replace('$$', ''))
                i += 1
            math_text = ' '.join(l for l in math_lines if l)
            math_text = sanitize_math(math_text)
            p = doc.add_paragraph()
            p.alignment = WD_ALIGN_PARAGRAPH.CENTER
            run = p.add_run(math_text)
            run.font.size = Pt(10)
            run.font.name = 'Cambria Math'
            run.italic = True
            continue

        if '|' in line and line.strip().startswith('|'):
            table_lines = []
            while i < len(lines) and '|' in lines[i]:
                table_lines.append(lines[i])
                i += 1
            add_md_table(doc, '\n'.join(table_lines))
            continue

        if line.strip():
            p = doc.add_paragraph()
            text = line.strip()
            parts = re.split(r'(\*\*\*[^*]+\*\*\*|\*\*[^*]+\*\*|\*[^*]+\*|\$[^$]+\$)', text)
            for part in parts:
                if part.startswith('***') and part.endswith('***'):
                    run = p.add_run(part[3:-3])
                    run.bold = True
                    run.italic = True
                    run.font.name = 'Times New Roman'
                    run.font.size = Pt(12)
                elif part.startswith('**') and part.endswith('**'):
                    run = p.add_run(part[2:-2])
                    run.bold = True
                    run.font.name = 'Times New Roman'
                    run.font.size = Pt(12)
                elif part.startswith('*') and part.endswith('*') and len(part) > 2:
                    run = p.add_run(part[1:-1])
                    run.italic = True
                    run.font.name = 'Times New Roman'
                    run.font.size = Pt(12)
                elif part.startswith('$') and part.endswith('$'):
                    math = part[1:-1]
                    for old, new in [('\\hat{\\beta}', '\u03b2\u0302'),
                                     ('\\beta', '\u03b2'), ('\\Delta', '\u0394'),
                                     ('\\times', '\u00d7'), ('\\gamma', '\u03b3')]:
                        math = math.replace(old, new)
                    math = re.sub(r'_\{([^}]+)\}', r'_\1', math)
                    math = re.sub(r'\^\{([^}]+)\}', r'^\1', math)
                    math = re.sub(r'\\[a-zA-Z]+', '', math)
                    math = ''.join(c for c in math if ord(c) >= 32 or c in '\n\t')
                    run = p.add_run(math)
                    run.italic = True
                    run.font.name = 'Cambria Math'
                    run.font.size = Pt(11)
                else:
                    run = p.add_run(part)
                    run.font.name = 'Times New Roman'
                    run.font.size = Pt(12)

        i += 1

    # Appendix: Figures
    doc.add_page_break()
    p = doc.add_heading('Appendix: Figures', level=0)
    p.alignment = WD_ALIGN_PARAGRAPH.CENTER
    for run in p.runs:
        run.font.size = Pt(16)
        run.font.name = 'Times New Roman'
        run.font.color.rgb = RGBColor(0, 0, 0)

    figure_files = [
        ("Figure 1: Z₁ Effect on Net vs Gross Positions", "forest_plot_z1.png"),
        ("Figure 2: KAOPEN Gating", "kaopen_gating.png"),
        ("Figure 3: Bilateral vs Multilateral Comparison", "bilateral_vs_multilateral.png"),
        ("Figure 4: Mediation Paths", "mediation_diagram.png"),
    ]
    for label, filename in figure_files:
        filepath = FIGURES_DIR / filename
        if not filepath.exists():
            continue
        p = doc.add_heading(label, level=1)
        for run in p.runs:
            run.font.size = Pt(13)
            run.font.name = 'Times New Roman'
            run.font.color.rgb = RGBColor(0, 0, 0)
        doc.add_picture(str(filepath), width=Inches(6))
        doc.add_paragraph()

    # Appendix: Tables
    doc.add_page_break()
    p = doc.add_heading('Appendix: Tables', level=0)
    p.alignment = WD_ALIGN_PARAGRAPH.CENTER
    for run in p.runs:
        run.font.size = Pt(16)
        run.font.name = 'Times New Roman'
        run.font.color.rgb = RGBColor(0, 0, 0)

    table_files = [
        ("Table 0: Summary Statistics", "summary_statistics.md"),
        ("Table 1: CA Decomposition", "net_decomposition_ca.md"),
        ("Table 1b: Pre/Post-GFC Decomposition", "net_decomposition_gfc.md"),
        ("Table 2: Savings-Investment Decomposition", "net_decomposition_si.md"),
        ("Table 3: Aggregate Gross Positions", "gross_positions_aggregate.md"),
        ("Table 3b: Aggregate (Excl Financial Centers)", "gross_positions_aggregate_exfc.md"),
        ("Table 3c: Aggregate (Winsorized)", "gross_positions_aggregate_winsorized.md"),
        ("Table 4: Instrument Breakdown (Full)", "gross_positions_instruments_full.md"),
        ("Table 4b: Instruments (Excl Financial Centers)", "gross_positions_instruments_exfc.md"),
        ("Table 4c: Instruments (Winsorized)", "gross_positions_instruments_winsorized.md"),
        ("Table 4d: Lifecycle vs Hot Money", "gross_positions_lifecycle_hot.md"),
        ("Table 5: Instrument Breakdown (OECD)", "gross_positions_instruments_oecd.md"),
        ("Table 6: KAOPEN Gating Aggregate", "kaopen_gating_aggregate.md"),
        ("Table 6b: KAOPEN Gating (Excl FC)", "kaopen_gating_aggregate_exfc.md"),
        ("Table 6c: KAOPEN Gating (Winsorized)", "kaopen_gating_aggregate_winsorized.md"),
        ("Table 7: KAOPEN Gating by Instrument", "kaopen_gating_instruments.md"),
        ("Table 8: Bilateral Bridge", "bilateral_bridge.md"),
        ("Table 8b: Bilateral Concordance", "bilateral_bridge_concordance.md"),
        ("Table 8c: Partner-Count Heterogeneity", "bilateral_bridge_partners.md"),
        ("Table 8d: Bilateral Noise Filter", "bilateral_bridge_noise_filter.md"),
        ("Table 9: Mediation Paths", "mediation_paths.md"),
        ("Table 10: Shapley-Owen Decomposition", "shapley_decomposition.md"),
        ("Table 11: First Differences", "dynamics_first_diff.md"),
        ("Table 12: Lagged Demographics", "dynamics_lagged.md"),
        ("Table 13: Pre/Post-GFC Gross Positions", "dynamics_gfc_split.md"),
        ("Table 13b: Chow Test (Income Balance)", "chow_test_income_balance.md"),
        ("Table 13c: Rate-Mediated Break", "dynamics_rate_mediated_break.md"),
        ("Table 14: Robustness Matrix", "robustness_matrix.md"),
        ("Z1 Summary", "gross_positions_z1_summary.md"),
    ]

    for label, filename in table_files:
        filepath = TABLES_DIR / filename
        if not filepath.exists():
            continue

        doc.add_page_break()
        p = doc.add_heading(label, level=1)
        for run in p.runs:
            run.font.size = Pt(13)
            run.font.name = 'Times New Roman'
            run.font.color.rgb = RGBColor(0, 0, 0)

        sections = parse_md_file(filepath)
        for section in sections:
            if section[0] == 'table':
                _, title, md = section
                if title and title != label:
                    add_md_table(doc, md, title=title)
                else:
                    add_md_table(doc, md)
            elif section[0] == 'note':
                p = doc.add_paragraph()
                run = p.add_run(section[1])
                run.italic = True
                run.font.size = Pt(9)
                run.font.name = 'Times New Roman'

    doc.save(str(OUTPUT))
    print(f"Saved: {OUTPUT}")
    print(f"Size: {OUTPUT.stat().st_size / 1024:.0f} KB")


if __name__ == '__main__':
    build_docx()
